Create Pivot Table
AutomatR.Excel.Activities.CreatePivotTable
The "Create Pivot Table" activity in AutomatR is part of the Excel activities package, designed to simplify the process of creating a pivot table from a specified range within an Excel workbook. This activity enhances the efficiency of automation workflows involving Excel data analysis.
Properties
| Name | Description |
|---|---|
| Destination | |
| Pivot Table Name | Enter the name of the new pivot table to be created. String variables containing the pivot table name. |
| Range | Enter the range specifying on which the pivot table will be created. String variables containing the range. |
| Input | |
| Sheet Name | Enter the name of the sheet from which the data for the pivot table will be sourced. String variables containing the sheet name. |
| Source Table Name | Enter the name of the source table for the pivot. String variables containing the source table name. |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Create Pivot Table" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
How to use:
- Drag and drop the "Create Pivot Table" activity onto the workflow.
- Configure the properties by specifying the sheet name, source table name, range, and the name of the new pivot table.
- Optionally, configure the delay.
- Execute the workflow to create the specified pivot table within the Excel workbook.
Example: Consider an example where the "Create Pivot Table" activity is used to create a new pivot table named "SalesPivotTable" from the source table "SalesData" in the sheet "DataSheet" within the range "A1:D100" with a 2-second delay:
Create Pivot Table:
Sheet Name: "DataSheet"
Source Table Name: "SalesData"
Range: "A1:D100"
Pivot Table Name: "SalesPivotTable"
Delay: 2
In this example, the activity creates a new pivot table named "SalesPivotTable" from the source table "SalesData" in the sheet "DataSheet" within the range "A1:D100" with a 2-second delay, allowing time for any necessary cleanup or synchronization.